﻿CREATE TABLE [dbo].[Employee] (
    [EmployeeID]     UNIQUEIDENTIFIER NOT NULL,
    [CreatedDate]    DATETIME         NOT NULL,
    [CreatedBy]      UNIQUEIDENTIFIER NOT NULL,
    [ModifiedDate]   DATETIME         NOT NULL,
    [ModifiedBy]     UNIQUEIDENTIFIER NOT NULL,
    [Deleted]        BIT              NOT NULL,
    [DesignationID]  UNIQUEIDENTIFIER NOT NULL,
    [DivisionID]     UNIQUEIDENTIFIER NOT NULL,
    [PersonID]       UNIQUEIDENTIFIER NOT NULL,
    [EmployeeNumber] VARCHAR (24)     NOT NULL
);

